﻿CREATE proc sp_suanhomvt
@MaNhomVT int,
@TenNhomVT nvarchar(200)
as
declare @dem as int
select @dem=count(*) from DanhMucnhomVT where ManhomVT=@MaNhomVT
if(@dem>0)
	begin
	update DanhMucNhomVt
	set TenNhomVT=@TenNhomVT
	Select ErrCode=1
	end
else	
	begin
	Select ErrCode=0
	end